create  table jms_dm.dm_ass_scan_effective_cnt_dt 
(
    network_code varchar(50) NULL COMMENT "网点code",
    operate_type tinyint(4) NULL COMMENT "模式",
    scan_date date NULL COMMENT "日期",
    network_name varchar(50) NULL COMMENT "网点名称",
    scan_cnt bigint(20) NULL COMMENT "操作量",
    usage_duration decimal(16, 4) NULL COMMENT "使用时长",
    effective decimal(16, 4) NULL COMMENT "效能",
    date_time date NULL COMMENT "查询日期" )
ENGINE=OLAP
DUPLICATE KEY(network_code, operate_type)
comment '供件台效能'
PARTITION BY RANGE (date_time) ( 
   START ("2023-07-01") END ("2023-07-23") EVERY (INTERVAL 1 day))
DISTRIBUTED BY HASH(operate_type) BUCKETS 1 
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-30",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "1",
"in_memory" = "false",
"storage_format" = "V2"
);